SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:"The Rock Ridge Community" Offering 326 pristine acres of nature, trails, and riverfront access to all that the Upper Valley has to offer. The Upper Valley's Premier Neighborhood, all New Construction. This new home offers over 2,000sf of living space that includes 3 bedroom,3 bath home. Open concept living with hardwood floors, Quartz counter tops, tiled baths, flexible floor plan and many other upgrades including mini splits, kitchen island, gas insert. Share the community garden, enjoy socials at the Farmhouse and the privileges that HOA provides. Close to I-89, DHMC and Dartmouth College, Lebanon 6 Theater, Downtown, and plenty of shopping. Photos show architectural renderings, similar style home and current construction progress. The target finish date is 05/29/2026
Description:A refined lakeside retreat with views of Mascoma Lake and a short walk to two shared sandy beaches, this beautifully maintained 3-bedroom, 3-bath home offers an exceptional balance of comfort and connection to nature. A rare opportunity, the property conveys with a boat slip on Mascoma Lake, allowing you to keep your boat in the water for $300 per year (plus a one-time $2,000 buy-in fee). The slip is optional and may transfer within the association if a future owner chooses not to continue it. Thoughtfully designed for both everyday living and relaxed entertaining, the home features a seamless flow from the living room—anchored by a wood-burning fireplace—to the dining area and through French doors to a screened porch with lake views, where summer evenings are defined by soft breezes and the unmistakable call of loons across the water. The kitchen is appointed with granite countertops, and the first floor also offers a versatile bedroom or office, full bath, and practical mudroom. Upstairs, the primary suite provides a private retreat with vaulted ceilings, a walk-in closet, and an ensuite full bath, along with an additional bedroom and full bath. The lower level expands the living space with a generous bonus room ideal for a family room, fitness area, or creative studio, plus a dedicated laundry room, storage room, utility room, and direct exterior access from the basement. Set within a quiet, well-kept community where outdoor recreation is just steps away—yet only minutes to I-89, Dartmouth Hitchcock, Dartmouth College, dining, and shopping—this home offers a rare blend of lake lifestyle and Upper Valley convenience.
Description:OPEN HOUSE CANCELLED – Perfectly positioned in the heart of the Upper Valley, this rare find offers a unique combination of privacy, convenience, and year-round recreation with Mascoma Lake steps away. Enjoy four seasons of lakeside living without the premium lakefront taxes! Nestled discreetly off the road, surrounded by mature trees, and set on a beautiful private 2-acre lot, this well-maintained two-story ranch offers over 2,800 sqft of living space, including a fully equipped detached cottage (ideal for rental income at $2K/month, or multi-generational living), and private beach access just a stroll away. The primary residence’s upper level features a spacious kitchen/dining area with scenic views of your private woods, a cozy living room with a wood-burning fireplace, two bedrooms, a full bath, and a balcony with stunning westerly sunset views over the lake. The lower walkout level has three finished rooms, a half bath, and a flexible workshop with ample storage. The detached cottage serves as a fully functional studio or in-law suite with a washer, cooktop, AC, full bath, parking, and a deck with lovely lake views. Additional features include a cute chicken coop w/ a custom-built run, two storage sheds, perennial gardens, a stone fire pit, and ample open yard space. Truly a unique property offering serene country living with easy access to outdoor recreation, minutes from Dartmouth Hitchcock Medical Center, Hanover, and Lebanon. Assumable VA Loan at 3% Interest (for Veterans only)! Seller is an NH Real Estate Agent.
Description:This property is unique! It is a newly built home located on 1.51 acres of gently rolling land in the coveted Lyme Common District, New Hampshire. Imagine the possibilities of a new light-filled home that offers all the ease of contemporary living with the space, privacy, and flexibility of a single- family property. Built for any imaginable future, the accessible first floor includes a large main bedroom, bath with walk-in shower, open concept kitchen with eating area and living area, family room, sunroom/mudroom, and laundry room. There is a full basement with an eight (8) foot ceiling, large enough for an exercise room or workshop. The timber-framed open-ceiling second floor has a full bath and two large bedrooms. One room is plumbed and could be converted to an efficiency kitchen/living area creating a complete second floor living space, perhaps for a roommate or home health-aid. The open lot is great for activities and there is plenty of additional building footprint potential with access from both Pleasant Street and High Street. If you are dreaming bigger, the existing structure can be reimagined as an in-law house while you construct a larger main residence on the same parcel, giving you the best of both worlds: immediate move-in ready living and the option to expand your dream estate. And if development is your dream, you might build multiple condo-homes. An additional nine (9) bedroom, septic has been designed with Town and State approval. Enjoy all the community activities that Lyme has to offer on the green, including farmers’ markets and summer concerts. You will be a short walk to the elementary/middle school, library, restaurants and the country store, and drive just a few minutes to swim and boat at Post Pond or ski the Dartmouth Skiway.
Description:Welcome to this beautifully updated Cape-style home featuring a two car garage and a level, landscaped yard-perfect for relaxing or entertaining. Thoughtfully designed, this home offers abundant space for family gatherings and special occasions. The stunning kitchen is a chef's dream, complete with stone countertops, a large center island the comfortably seats four, and new stainless steel appliances. Just off the kitchen, the expansive dining room provides ample space for hosting large family dinners. Sunlight pours into the inviting living room, which flows seamlessly into a den with a charming fireplace. A stylish renovated 3/4 bath completes the first floor. Upstairs, you'll find two comfortable guest bedrooms, and a private suite featuring a walk-in closet, private sauna and direst access to a remodeled 3/4 bath. The finished walkout basement offers even more living space with two additional rooms, a generous family room and a third 3/4 bath. With plenty of updates this house is ready for you to make it your home!